BEGIN{FS="\t"}
{
  # 1:date 2:uuid 3:appId 4:adId 5:price 6 adtype 7 version 8:ip 9:channel 10:pad
  kind="count";
  key=$2"_"$3"_"$4"_"$8
  if(($2!="800000000000")&&($2!="")){
     if(key in count){
       count[key]+=1;
     }else{
       count[key]=1;
     }
     date[key]=substr($1,1,10);
     time[key]=substr($1,12,2);
     appId[key]=$3;
     adId[key]=$4;
     price[key]=$5;
     adType[key]=$6;
  }
}
END{
  for(i in count){
    printf("%s\t%s\t%s\t%s\t%s\t%s\t%s\n",date[i],time[i],appId[i],adId[i],price[i],adType[i],count[i]);
  }
}
